package org.nmgyjt.springboot.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Select;
import org.nmgyjt.springboot.entity.admin.CsSystemSourceExt;

import java.util.List;
import java.util.Map;

/**
 * <p>
 *  Mapper 接口
 * </p>
 *
 * @author [mybatis plus generator]
 * @since 2023-07-12
 */
public interface CsSystemSourceExtMapper extends BaseMapper<CsSystemSourceExt> {
    @Select("SELECT ext.id id,ext.menu_id menuId,admin.phone phone,ext.org_id orgId FROM t_cs_system_source_ext ext LEFT JOIN t_cs_system_admin admin ON ext.org_id=admin.org_id\n" +
            " WHERE ext.menu_id IN ('1000000010','1000000011','1000000012','1000000014') AND admin.phone <> '' AND\n" +
            " admin.phone IS NOT NULL AND ext.snyc_state <> '0'")
    List<Map<String,String>> findExtList();

}
